package com.budwk.app.sqfwV2.dto.entity;

import com.budwk.starter.common.openapi.annotation.ApiModel;
import com.budwk.starter.common.openapi.annotation.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;
import org.nutz.dao.entity.annotation.*;
import org.nutz.dao.interceptor.annotation.PrevInsert;

import java.time.LocalDateTime;

/**
 * @author ZY.Wang
 * @since 2024/7/19
 */
@Data
@Accessors(chain = true)
@Table("shequ.sqfw_poverty_upload")
@Comment("扶贫监测文件导入")
@ApiModel(description = "扶贫监测文件导入")
public class SqfwPovertyUpload {

    @Column
    @Name
    @Comment("编号")
    @ApiModelProperty(description = "ID")
    @ColDefine(type = ColType.VARCHAR, width = 32)
    @PrevInsert(els = {@EL("snowflake()")}, nullEffective = true)
    private String id;

    @Column("year")
    @Comment("年")
    @ApiModelProperty(description = "年")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String year;

    @Column("quarter")
    @Comment("季度")
    @ApiModelProperty(description = "季度")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String quarter;

    @Column("template_url")
    @Comment("模板文件url")
    @ApiModelProperty(description = "模板文件url")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String templateUrl;

    @Column("upload_file_url")
    @Comment("上传文件")
    @ApiModelProperty(description = "上传文件")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String uploadFileUrl;

    @Column("upload_file_name")
    @Comment("上传的文件名")
    @ApiModelProperty(description = "上传的文件名")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String uploadFileName;

    @Column("province")
    @Comment("省份")
    @ApiModelProperty(description = "省份")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String province;

    @Column("city")
    @Comment("城市")
    @ApiModelProperty(description = "城市")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String city;

    @Column("district")
    @Comment("区")
    @ApiModelProperty(description = "区")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String district;

    @Column("county")
    @Comment("县")
    @ApiModelProperty(description = "县")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String county;

    @Column("community")
    @Comment("社区")
    @ApiModelProperty(description = "社区")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String community;

    @Column("create_by")
    @Comment("提交人")
    @ApiModelProperty(description = "提交人")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String createBy;

    @Column("create_time")
    @Comment("提交时间")
    @ApiModelProperty(description = "提交时间")
    @ColDefine(type = ColType.DATETIME, width = 50)
    private LocalDateTime createTime;

    @Column("update_by")
    @Comment("修改人")
    @ApiModelProperty(description = "修改人")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private String updateId;

    @Column("update_time")
    @Comment("修改时间")
    @ApiModelProperty(description = "修改时间")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    private LocalDateTime updateTime;
}
